object fmFaturaAktarim: TfmFaturaAktarim
  Left = 13
  Top = 30
  Width = 1235
  Height = 641
  Caption = 'Fatura Aktar'#305'm'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object cxGrid1: TcxGrid
    Left = 0
    Top = 96
    Width = 1227
    Height = 227
    Align = alTop
    TabOrder = 0
    object cxGrid1DBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      DataController.DataSource = DSdetay
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsBehavior.AlwaysShowEditor = True
      OptionsBehavior.IncSearch = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsSelection.CellSelect = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.GroupByBox = False
      OptionsView.Indicator = True
      object cxGrid1DBTableView1STFICHELNNO: TcxGridDBColumn
        Caption = 'S'#305'ra No'
        DataBinding.FieldName = 'STFICHELNNO'
        Width = 71
      end
      object cxGrid1DBTableView1unitystokkodu: TcxGridDBColumn
        Caption = 'Stok Kodu'
        DataBinding.FieldName = 'unitystokkodu'
        Width = 161
      end
      object cxGrid1DBTableView1AMOUNT: TcxGridDBColumn
        Caption = 'Miktar'
        DataBinding.FieldName = 'AMOUNT'
        Width = 65
      end
      object cxGrid1DBTableView1VAT: TcxGridDBColumn
        Caption = 'Kdv'
        DataBinding.FieldName = 'VAT'
        Width = 85
      end
      object cxGrid1DBTableView1PRICE: TcxGridDBColumn
        Caption = 'Tutar'
        DataBinding.FieldName = 'PRICE'
        Width = 80
      end
      object cxGrid1DBTableView1TOTAL: TcxGridDBColumn
        Caption = 'Toplam Tutar'
        DataBinding.FieldName = 'TOTAL'
        Width = 101
      end
    end
    object cxGrid1Level1: TcxGridLevel
      GridView = cxGrid1DBTableView1
    end
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 1227
    Height = 71
    Align = alTop
    TabOrder = 1
    object Label2: TLabel
      Left = 16
      Top = 31
      Width = 74
      Height = 13
      Caption = 'Aktar'#305'lan Fatura'
    end
    object Label1: TLabel
      Left = 16
      Top = 8
      Width = 71
      Height = 13
      Caption = 'Toplam  Fatura'
    end
    object StaticText1: TStaticText
      Left = 104
      Top = 5
      Width = 91
      Height = 21
      AutoSize = False
      BorderStyle = sbsSunken
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 0
    end
    object StaticText2: TStaticText
      Left = 104
      Top = 28
      Width = 91
      Height = 21
      AutoSize = False
      BorderStyle = sbsSunken
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 1
    end
    object bFatOku: TButton
      Left = 211
      Top = 5
      Width = 110
      Height = 21
      Caption = 'Fatura Oku'
      TabOrder = 2
      OnClick = bFatOkuClick
    end
    object bKontrol: TButton
      Left = 211
      Top = 28
      Width = 110
      Height = 21
      Caption = 'Fatura Aktar'#305'm'
      TabOrder = 3
      OnClick = bKontrolClick
    end
    object PB: TProgressBar
      Left = 16
      Top = 53
      Width = 305
      Height = 14
      TabOrder = 4
    end
  end
  object SB: TfcStatusBar
    Left = 0
    Top = 584
    Width = 1227
    Height = 30
    Hint = 'Ayr'#305'nt'#305's'#305'n'#305' G'#246'rmek '#304#231'in '#199'ift T'#305'klay'#305'n'#305'z.'
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -15
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    Panels = <
      item
        Font.Charset = TURKISH_CHARSET
        Font.Color = clRed
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        Name = 'Panel0'
        Tag = 0
        TextOptions.Alignment = taLeftJustify
        TextOptions.VAlignment = vaVCenter
        Width = '50'
      end>
    ParentFont = False
    ParentShowHint = False
    ShowHint = True
    SimplePanel = False
    SizeGrip = False
    StatusBarText.CapsLock = 'Caps'
    StatusBarText.Overwrite = 'Overwrite'
    StatusBarText.NumLock = 'Num'
    StatusBarText.ScrollLock = 'Scroll'
  end
  object Panel2: TPanel
    Left = 0
    Top = 71
    Width = 1227
    Height = 25
    Align = alTop
    Caption = 'Unity Fatura Detay'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 3
  end
  object Panel3: TPanel
    Left = 0
    Top = 331
    Width = 1227
    Height = 25
    Align = alTop
    Caption = 'Unity Fatura'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 4
  end
  object cxGrid2: TcxGrid
    Left = 0
    Top = 356
    Width = 1227
    Height = 228
    Align = alClient
    TabOrder = 5
    object cxGridDBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      OnCellClick = cxGridDBTableView1CellClick
      DataController.DataSource = DS
      DataController.Summary.DefaultGroupSummaryItems = <
        item
          Format = 'Adet : ###.###'
          Kind = skCount
          FieldName = 'TIPI'
          Column = cxGridDBColumn10
        end>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsBehavior.AlwaysShowEditor = True
      OptionsBehavior.IncSearch = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsSelection.CellSelect = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.ColumnAutoWidth = True
      OptionsView.Indicator = True
      object cxGridDBColumn1: TcxGridDBColumn
        Caption = #304'pt.'
        DataBinding.FieldName = 'Iptal'
        Width = 46
      end
      object cxGridDBTableView1SOURCEINDEX: TcxGridDBColumn
        Caption = 'Ambar'
        DataBinding.FieldName = 'AMBARADI'
      end
      object cxGridDBColumn2: TcxGridDBColumn
        Caption = 'Fatura No'
        DataBinding.FieldName = 'FICHENO'
        Width = 73
      end
      object cxGridDBColumn3: TcxGridDBColumn
        Caption = #304'rsaliye No'
        DataBinding.FieldName = 'unityirsaliyeno'
        Width = 73
      end
      object cxGridDBColumn4: TcxGridDBColumn
        Caption = 'Sipari'#351' No'
        DataBinding.FieldName = 'DOCODE'
        Width = 73
      end
      object cxGridDBColumn5: TcxGridDBColumn
        Caption = 'Cari Kodu'
        DataBinding.FieldName = 'unitycarikodu'
        Width = 99
      end
      object cxGridDBColumn6: TcxGridDBColumn
        Caption = #220'nvan'#305
        DataBinding.FieldName = 'unityunvan'
        Width = 237
      end
      object cxGridDBColumn7: TcxGridDBColumn
        Caption = 'Fatura A'#231#305'klama'
        DataBinding.FieldName = 'aciklama'
        Width = 186
      end
      object cxGridDBColumn8: TcxGridDBColumn
        Caption = 'Tutar'
        DataBinding.FieldName = 'GROSSTOTAL'
        Width = 76
      end
      object cxGridDBColumn9: TcxGridDBColumn
        Caption = 'Kdvli Tutar'
        DataBinding.FieldName = 'NETTOTAL'
        Width = 80
      end
      object cxGridDBColumn10: TcxGridDBColumn
        Caption = 'Sevkiyat Tipi'
        SortIndex = 0
        SortOrder = soAscending
        Width = 102
      end
      object cxGridDBColumn11: TcxGridDBColumn
        Caption = 'Fatura Tipi'
        DataBinding.FieldName = 'TIPI'
        Width = 78
      end
    end
    object cxGridLevel1: TcxGridLevel
      GridView = cxGridDBTableView1
    end
  end
  object cxSplitter1: TcxSplitter
    Left = 0
    Top = 323
    Width = 1227
    Height = 8
    HotZoneClassName = 'TcxXPTaskBarStyle'
    AlignSplitter = salTop
    Control = cxGrid1
  end
  object DS: TDataSource
    Left = 400
    Top = 424
  end
  object DSdetay: TDataSource
    DataSet = adoFatDetay
    Left = 400
    Top = 176
  end
  object adoFatDetay: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select LOGICALREF,STFICHEREF,STFICHELNNO,STOCKREF,'
      
        '       unitystokkodu=(SELECT CODE FROM LG_018_ITEMS WHERE LG_018' +
        '_ITEMS.LOGICALREF=LG_018_01_STLINE.STOCKREF),'
      '       AMOUNT,VAT,PRICE,TOTAL,REPORTRATE,ORDFICHEREF'
      'from LG_018_01_STLINE '
      'where STFICHEREF =100'
      'AND LINETYPE=0')
    Left = 472
    Top = 176
  end
end
